Adding and Modifying Queries
To add a new query, press the F6 key from the Work with Queries screen (STRFW > 41 > 1) as shown in Creating and Running Queries.
To modify an existing query, enter 1 in the Opt field for the query on the Work with Queries screen.
The Add Query or Modify Query screen appears. (The only differences between them are the screen title and that some fields for the Modify Query screen are read-only, as noted in their descriptions.)
| Add Query Last change date 0/00/00 by user Type choices, press Enter. Query name . . . . . Description . . . . . Type (00=All) . . . . 00 Generic entry type (00-99 for reporting only) Not Name Time group . . . . . N=Not in time group Output format . . . . 2 1=Tabular and wrap, 2=One line, 9=Log If Output=1, Wrap on. 0 Field number, 0=*AUTO Add Header / Total . 1 1=Both, 2=Header, 3=Total, 4=Total only, 9=None Add Filter / Desc. . 1 1=Filter and description, 2=Filter, 3=Description, 9=None Password . . . . . . F3=Exit F4=Prompt F12=Cancel |
The screen contains the following fields:
Query name
A unique name for the query. Do not begin the name with the letter "Z", which is reserved for queries included with iSecurity products. (For Modify Query, this field is read-only.)
Description
A free-form description of the query.
Type
A code indicating the type of the query. For a list of possible values, press the F4 key. (For Modify Query, this field is read-only.)
The type $9 is a special value, with which you can use the output from any command as input for the query. If you set this field to $9, the Spool File Query Selection screen appears after this screen, in which you can specify the command.
Time group
Restrict information to times within a named time group or, if the first one-character field is set to N, to times outside of it. For a list of valid time groups, press the F4 key.
Output format
The format in which each line of output appears. Possible values are:
- 1: Display in tabular format. If the data is longer than an output line, wrap on the field of the data indicated on the next field of this screen.
- 2: Display in tabular format on a single line.
- 9: Display in log format.
If Output=1, Wrap on
If the Output format field is set to 1, the number of the data field on which to start a new line. If this field is set to 0, wrap output to the next line at the start of any data field that would cause the output to exceed its maximum line length.
Add Header / Total
Whether the output should include field headers or a summary of totals. Possible values include:
- 1: Include both the headers and summary.
- 2: Include only the header.
- 3: Include the summary.
- 4: Omit the body of the report and include the summary.
- 9: Include neither headers nor summary.
Add Filter / Desc.
Whether the output should include a listing of the query's filter conditions or a text description of them. Possible values include:
- 1: Include both filter and description.
- 2: Include only the header
- 3: Description
- 4: Include neither filter nor description.
Password
Add a password to this query to protect it from being changed. This is a hidden field, without an underline marking its location. It begins on the same line as its label, in the same column as the entry areas for the other fields.
After entering values for the fields, press Enter.
If you set the Type (00-All) field to $9, the Spool File Query Selection screen appears. Specify the command string, then press Enter.
The Filter Conditions screen appears, as shown in Setting Filter Conditions. Set the filter conditions for the query, then press Enter,
The Select Output Fields screen appears, as shown in Selecting Output Fields for Queries and Reports. Select the output fields and the order in which they appear on lines of output, then press Enter.
The Select Sort Fields screen appears, as shown in Selecting Sort Fields for Queries and Reports. Select the order in which the data records will be sorted in the output, then press Enter.
The Exit Query Definition screen appears:
| Exit Query Definition Query . . . . . TESTJZ Test for Documentation Type . . . . . 00 Generic entry type (00-99 for reporting only) Type choices, press Enter. Summaries . . . . . . N Y=Yes, N=No Explanation . . . . . N Y=Yes, N=No Save . . . . . . . . Y Y=Yes, N=No Schedule . . . . . . N Y=Yes, N=No Run . . . . . . . . . Y Y=Yes, N=No F3=Exit F12=Cancel |
The screen includes the following fields. For each, enter Y for "Yes" or N for "No".
Summaries
Whether the output include a summary of totals. If set to Y, the Modify Query Summary Definitions screen appears after you press Enter, as shown in Modifying Query Summary Definitions.
Explanation
Whether the output should include text description in its header. If set to Y, the Query Explanation and Classification screen appears after you press Enter, as shown in Creating Query Classifications and Explanations.
Save
Whether to save the query definition.
Schedule
Whether to add the query to a group to run on a schedule. If set to Y, the Schedule Query screen appears after you press Enter, as shown in Scheduling Queries.
Run
Whether to run the query immediately. If set to Y, the Run Firewall Query (RUNFWQRY) screen appears after you press Enter, as shown in .
To save your selections and exit the screen, press Enter. The additional screens related to your selections appear.
To exit the screen without saving your selections, press the F12 key.